package com.etooling.pdm.repository;

import com.etooling.framework.repository.BaseRepository;
import com.etooling.pdm.entity.GoodsSpecsPropValues;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface GoodsSpecsPropValuesRepository extends BaseRepository<GoodsSpecsPropValues> {
    /**
     * 获取。value,code,setting_id
     * @param settingIds
     * @return
     */
    @Query(nativeQuery = true, value = "select value,code,setting_id from pdm.t_goods_specs_prop_values where setting_id in ?1 ")
    List<Map<String, Object>> getInfoBySettingIds(List<String> settingIds);


}
